Members login
grant SELECT on eBD_TurismeBCN_data.TBCN2_ENLACES_PIE to 'lecturapie'@'%' identified by 'lectura7pie11';
Query OK, 0 rows affected (0.05 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
*
* +----------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+----------------+
| _idRegistro | int(11) | | PRI | NULL | auto_increment |
| _publicado | enum('S','N') | YES | | NULL | |
| _username | varchar(100) | YES | | NULL | |
| _insercion | datetime | YES | | NULL | |
| _modificacion | datetime | YES | | NULL | |
| idEnlace | int(11) | YES | | NULL | |
| web | varchar(255) | YES | | NULL | |
| urlCAT | varchar(255) | YES | | NULL | |
| urlCAST | varchar(255) | YES | | NULL | |
| urlENG | varchar(255) | YES | | NULL | |
| urlFRA | varchar(255) | YES | | NULL | |
| orden | int(11) | YES | | NULL | |
| descripcioCAT | varchar(255) | YES | | NULL | |
| descripcioCAST | varchar(255) | YES | | NULL | |
| descripcioENG | varchar(255) | YES | | NULL | |
| descripcioFRA | varchar(255) | YES | | NULL | |
| visible | enum('S','N') | YES | MUL | N | |
| webHeader | varchar(255) | YES | MUL | NULL | |
| visibleHeader | enum('S','N') | YES | MUL | N | |
+----------------+---------------+------+-----+---------+----------------+
*/
$DB_NAME = 'eBD_TurismeBCN_data';
$DB_HOST = '172.28.1.3';
$DB_USER = 'lecturapie';
$DB_PASS = 'lectura7pie11';
$mysqli = new mysqli($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
if (mysqli_connect_errno()) {
printf("Connexió fallida: %s\n", mysqli_connect_error());
exit();
}
$tw_base = 'VisitBCN_';
$tw_lang = 'EN';
$isolang = 'en';
$isolang_urlWeb = 'en';
$prof = '';
$web = filter_input(INPUT_GET, 'web', FILTER_SANITIZE_NUMBER_INT);
if(isset($_REQUEST['prof']) && $_REQUEST['prof']!=''){
$prof = strtolower(preg_replace('[^A-Za-z]', '', $_REQUEST['base']));
if($prof=='s'){
$tw_base = 'BarcelonaInfo';
}
}
if(isset($_REQUEST['lang']) && $_REQUEST['lang']!=''){
$lang = strtolower(preg_replace('[^A-Za-z1-6]', '', $_REQUEST['lang']));
switch ($lang){
case 'ca':
case '1':
$extidioma = 'CAT';
$tw_lang = 'CAT';
$isolang = 'ca';
$isolang_urlWeb = 'ca';
//$cookieAlert = "En aquest web utilitzem cookies pròpies i de tercers per millorar i personalitzar els nostres serveis i facilitar-te la navegació. Si continues navegant, considerem que nâacceptes la instal·lació i ús. Pots canviar la configuració o obtenir més informació aquÃ.";
$cookieAlert = "En aquest web utilitzem cookies pròpies i de tercers per millorar i personalitzar els nostres serveis i facilitar-te la navegació. Si continues navegant, considerem que nâacceptes la instal·lació i ús. Pots canviar la configuració o obtenir més informació aquÃ.";
$cookieClose ="Tancar";
if($prof=='s'){
$tw_lang = '';
$tw_base = 'BarcelonaTurism';
}
$quiSom_txt = 'Qui som';
break;
case 'es':
case '2':
$extidioma = 'CAST';
$tw_lang = 'ES';
$isolang = 'es';
$isolang_urlWeb = 'es';
$cookieAlert = "En esta web utilizamos cookies propias y de terceros para mejorar y personalizar nuestros servicios y facilitarte la navegación. Si continuas navegando, consideramos que aceptas su instalación y uso. Puedes cambiar la configuración u obtener más información aquÃ.";
$cookieClose ="Cerrar";
$quiSom_txt = 'Quiénes somos';
break;
case 'fr':
case '4':
$extidioma = 'FRA';
$tw_lang = 'FR';
$isolang = 'fr';
$isolang_urlWeb = 'fr';
$cookieAlert = "Sur cette page web nous utilisons des cookies propres et de tiers pour améliorer et personnaliser nos services et faciliter la navigation. Si vous continuez à naviguer, nous considérons que vous acceptez leur installation et leur usage. Vous pouvez changer la configuration ou obtenir plus d'information ici.";
$cookieClose ="Close";
$quiSom_txt = 'A propos de nous';
break;
case 'it':
case '6':
$extidioma = 'ENG';
$tw_lang = 'EN';
$isolang = 'it';
$isolang_urlWeb = 'en';
$cookieAlert = "In questa web utilizziamo cookies propri e di terzi per migliorare e personalizzare i nostri servizi e per facilitarvi la navigazione. Se restate collegati, considereremo che accettate la loro installazione e il loro uso. Potete cambiare la configurazione e ottenere maggiori informazioni cliccando qui.";
$cookieClose ="Close";
if($prof=='s'){
$tw_lang = 'IT';
}
$quiSom_txt = 'About us';
break;
case 'en':
case '3':
$extidioma = 'ENG';
$tw_lang = 'EN';
$isolang = 'en';
$isolang_urlWeb = 'en';
$cookieAlert = "Our website uses its own cookies and third-party cookies to improve and personalise our services and make it easier to browse the site. If you continue to use this site we will assume that you are happy with this. You can change your settings or receive more information here.";
$cookieClose ="Close";
$quiSom_txt = 'About us';
break;
default :
$extidioma = 'ENG';
$tw_lang = 'EN';
$isolang = 'en';
$isolang_urlWeb = 'en';
$cookieAlert = "Our website uses its own cookies and third-party cookies to improve and personalise our services and make it easier to browse the site. If you continue to use this site we will assume that you are happy with this. You can change your settings or receive more information here.";
$cookieClose ="Close";
$quiSom_txt = 'About us';
break;
}
}else{
$extidioma = 'ENG';
$tw_lang = 'EN';
$isolang = 'en';
$isolang_urlWeb = 'en';
$cookieAlert = "Our website uses its own cookies and third-party cookies to improve and personalise our services and make it easier to browse the site. If you continue to use this site we will assume that you are happy with this. You can change your settings or receive more information here.";
$cookieClose ="Close";
}
//Obtener información de los enlaces
$query = ""
. "SELECT _idRegistro,webHeader as web, IF(url" . $extidioma . " IS NULL OR url" . $extidioma . "='', urlCAT, url" . $extidioma . ") as url, IF(descripcio" . $extidioma . " IS NULL,IF(descripcioCAT IS NULL,web, descripcioCAT), descripcio" . $extidioma . ") as title "
. "FROM TBCN2_ENLACES_PIE "
. "WHERE visibleHeader='S' "
. "ORDER BY orden, web "
. "LIMIT 5";
$result = $mysqli->query($query) or die($mysqli->error . __LINE__);
?>
?>
Visit Barcelona
*/ ?>
num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$currentStyle = '';
if ($web==$row['_idRegistro']){
$currentStyle = 'class="current"';
}
?>
> >
?>
MENU
